package msr.util;

/**
 * JAVAでPLSQLという関数を呼び出すインタフェース
 * */
public interface QueryDefine {

	/**
	 * call plsql function to query data from oracle db
	 * */
	// upuser 取得
	public final static String QUERY_GET_UPUSER = "{? = call user_cursor.getUpUser(?)}";
	// 予約一覧取得
	public final static String QUERY_ALL_YOYAKU = "{? = call yoyaku_cursor.getallyoyaku}";
	// 予約オブジェクト取得
	public final static String QUERY_YOYAKU = "{? = call yoyaku_cursor.getyoyaku(?)}";
	// Seqnoで予約オブジェクト取得
	public final static String QUERY_YOYAKU_BY_SEQ = "{? = call yoyaku_cursor.getyoyakuByNo(?)}";

	// public final static String QUERY_PRODUCT_BY =
	// "{? = call product_cursor.getproductby(?,?)}";
	// public final static String QUERY_PRODUCT =
	// "{? = call product_cursor.getproducts}";
	
	public final static String QUERY_PRODUCT = "{? = call product_cursor.getpipelineproducts}";
	public final static String QUERY_PRODUCT_BY = "{? = call product_cursor.getpipelineproductby(?,?)}";

	public final static String QUERY_PRODUCT_CAPACITY = "{? = call capacity_cursor.getcapacity(?)}";
	public final static String QUERY_ALL_USER = "{? = call user_cursor.getAllUser}";
	public final static String QUERY_USER = "{? = call user_cursor.getUser(?,?)}";
	public final static String QUERY_USER_BY_ID = "{? = call user_cursor.getUserByUsername(?)}";
	public final static String QUERY_SHIP_BY = "{? = call ship_cursor.getShip(?)}";

	public final static String QUERY_GET_LIST_DPLN = "{? = call dpln_cursor.getdpln(?,?)}";
	public final static String QUERY_GET_LIST_DPLN_SUPDATE = "{? = call dpln_cursor.getdplnSup(?,?,?)}";
	public final static String QUERY_GET_LIST_DPLN_FEEDCD = "{? = call dpln_cursor.getdplnFeedCd(?,?,?)}";
	public final static String QUERY_GET_LIST_DPLN_CUSTOM = "{? = call dpln_cursor.getdplnplus(?,?,?,?)}";

	public static final String QUERY_JICHIKU_BY_USER = "{? = call jichiku_cursor.getjichikubyuser(?)}";
	public static final String QUERY_JICHIKU_BY_DPLN = "{? = call jichiku_cursor.getjichikubydpln(?)}";

	public final static String QUERY_CHANGE_PASSWD = "{call update_passwd(?,?)}";
	public static final String UPDATE_YOYAKU = "{call yoyaku_cursor.update_yoyaku(?,?,?,?,?,?,?,?,?,?)}";
	public static final String DELETE_YOYAKU = "{call yoyaku_cursor.delete_yoyaku(?,?,?)}";
	public final static String QUERY_ADD_BOOKING = "{call yoyaku_cursor.add_yoyaku(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";

	public static final String QUERY_NOKISAKI_NEW = "{? = call jichiku_cursor.getNokisaki(?,?)}";

	// public static final String QUERY_NOKISAKI_HISTORY =
	// "{? = call dpln_cursor.nokisakiHistory(?)}";

	/**
	 * define constant for query
	 * */

	public final static String USER_NAME = "WEB_USER";
	public final static String PASSWD = "PASSWORD";
	public final static String AND = "AND";
	public final static String OR = "OR";
	public final static String PRODUCT_NAME = "FEED_NAME";
	public final static String PRODUCT_CD = "FEED_CD";
	public final static String LIKE = "LIKE";
	public final static String SPACE = " ";

}
